using HKB.Common;
using System;
using System.CodeDom.Compiler;
using System.ComponentModel;
using System.ComponentModel.Design;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Diagnostics;
namespace HKB.Data.Dal.S_ClassTableAdapters
{
	[GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0"), DataObject(true), HelpKeyword("vs.data.TableAdapter"), Designer("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"), DesignerCategory("code"), ToolboxItem(true)]
	public class HLShop_ClassTableAdapter : Component
	{
		private SqlDataAdapter _adapter;
		private SqlConnection _connection;
		private SqlCommand[] _commandCollection;
		private bool _clearBeforeFill;
		[System.Diagnostics.DebuggerNonUserCode]
		private SqlDataAdapter Adapter
		{
			get
			{
				if (this._adapter == null)
				{
					this.InitAdapter();
				}
				return this._adapter;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		internal SqlConnection Connection
		{
			get
			{
				if (this._connection == null)
				{
					this.InitConnection();
				}
				return this._connection;
			}
			set
			{
				this._connection = value;
				if (this.Adapter.InsertCommand != null)
				{
					this.Adapter.InsertCommand.Connection = value;
				}
				if (this.Adapter.DeleteCommand != null)
				{
					this.Adapter.DeleteCommand.Connection = value;
				}
				if (this.Adapter.UpdateCommand != null)
				{
					this.Adapter.UpdateCommand.Connection = value;
				}
				for (int i = 0; i < this.CommandCollection.Length; i++)
				{
					if (this.CommandCollection[i] != null)
					{
						this.CommandCollection[i].Connection = value;
					}
				}
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		protected SqlCommand[] CommandCollection
		{
			get
			{
				if (this._commandCollection == null)
				{
					this.InitCommandCollection();
				}
				return this._commandCollection;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public bool ClearBeforeFill
		{
			get
			{
				return this._clearBeforeFill;
			}
			set
			{
				this._clearBeforeFill = value;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public HLShop_ClassTableAdapter()
		{
			this.ClearBeforeFill = true;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitAdapter()
		{
			this._adapter = new SqlDataAdapter();
			DataTableMapping dataTableMapping = new DataTableMapping();
			dataTableMapping.SourceTable = "Table";
			dataTableMapping.DataSetTable = "HLShop_Class";
			dataTableMapping.ColumnMappings.Add("ClassID", "ClassID");
			dataTableMapping.ColumnMappings.Add("ChannelID", "ChannelID");
			dataTableMapping.ColumnMappings.Add("SpecialID", "SpecialID");
			dataTableMapping.ColumnMappings.Add("ClassName", "ClassName");
			dataTableMapping.ColumnMappings.Add("ClassType", "ClassType");
			dataTableMapping.ColumnMappings.Add("OpenType", "OpenType");
			dataTableMapping.ColumnMappings.Add("ParentID", "ParentID");
			dataTableMapping.ColumnMappings.Add("ParentPath", "ParentPath");
			dataTableMapping.ColumnMappings.Add("ParentDepth", "ParentDepth");
			dataTableMapping.ColumnMappings.Add("Depth", "Depth");
			dataTableMapping.ColumnMappings.Add("RootID", "RootID");
			dataTableMapping.ColumnMappings.Add("Child", "Child");
			dataTableMapping.ColumnMappings.Add("arrChildID", "arrChildID");
			dataTableMapping.ColumnMappings.Add("PrevID", "PrevID");
			dataTableMapping.ColumnMappings.Add("NextID", "NextID");
			dataTableMapping.ColumnMappings.Add("OrderByID", "OrderByID");
			dataTableMapping.ColumnMappings.Add("Tips", "Tips");
			dataTableMapping.ColumnMappings.Add("ReadMe", "ReadMe");
			dataTableMapping.ColumnMappings.Add("LinkUrl", "LinkUrl");
			dataTableMapping.ColumnMappings.Add("ParentDir", "ParentDir");
			dataTableMapping.ColumnMappings.Add("SkinID", "SkinID");
			dataTableMapping.ColumnMappings.Add("TemplateID", "TemplateID");
			dataTableMapping.ColumnMappings.Add("ShowOnTop", "ShowOnTop");
			dataTableMapping.ColumnMappings.Add("ShowOnIndex", "ShowOnIndex");
			dataTableMapping.ColumnMappings.Add("IsElite", "IsElite");
			dataTableMapping.ColumnMappings.Add("EnableAdd", "EnableAdd");
			dataTableMapping.ColumnMappings.Add("MaxPerPage", "MaxPerPage");
			dataTableMapping.ColumnMappings.Add("ItemListOrderType", "ItemListOrderType");
			dataTableMapping.ColumnMappings.Add("ItemOpenType", "ItemOpenType");
			dataTableMapping.ColumnMappings.Add("ClassDir", "ClassDir");
			dataTableMapping.ColumnMappings.Add("ItemCount", "ItemCount");
			dataTableMapping.ColumnMappings.Add("ShopCount", "ShopCount");
			dataTableMapping.ColumnMappings.Add("CheckComment", "CheckComment");
			dataTableMapping.ColumnMappings.Add("PresentExp", "PresentExp");
			dataTableMapping.ColumnMappings.Add("ProductTemplateID", "ProductTemplateID");
			dataTableMapping.ColumnMappings.Add("ProductSkinID", "ProductSkinID");
			dataTableMapping.ColumnMappings.Add("ClassSkinID", "ClassSkinID");
			dataTableMapping.ColumnMappings.Add("HasParameter", "HasParameter");
			this._adapter.TableMappings.Add(dataTableMapping);
			this._adapter.DeleteCommand = new SqlCommand();
			this._adapter.DeleteCommand.Connection = this.Connection;
			this._adapter.DeleteCommand.CommandText = "DELETE FROM [HLShop_Class] WHERE (([ClassID] = @Original_ClassID))";
			this._adapter.DeleteCommand.CommandType = CommandType.Text;
			this._adapter.DeleteCommand.Parameters.Add(new SqlParameter("@Original_ClassID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ClassID", DataRowVersion.Original, false, null, "", "", ""));
			this._adapter.InsertCommand = new SqlCommand();
			this._adapter.InsertCommand.Connection = this.Connection;
			this._adapter.InsertCommand.CommandText = "INSERT INTO [HLShop_Class] ([ChannelID], [SpecialID], [ClassName], [ClassType], [OpenType], [ParentID], [ParentPath], [ParentDepth], [Depth], [RootID], [Child], [arrChildID], [PrevID], [NextID], [OrderByID], [Tips], [ReadMe], [LinkUrl], [ClassDir], [ParentDir], [SkinID], [ShowOnTop], [ShowOnIndex], [IsElite], [EnableAdd], [MaxPerPage], [ItemListOrderType], [ItemOpenType], [ItemCount], [CheckComment], [PresentExp], [ShopCount], [ClassSkinID], [TemplateID], [ProductTemplateID], [ProductSkinID],[HasParameter]) VALUES (@ChannelID, @SpecialID, @ClassName, @ClassType, @OpenType, @ParentID, @ParentPath, @ParentDepth, @Depth, @RootID, @Child, @arrChildID, @PrevID, @NextID, @OrderByID, @Tips, @ReadMe, @LinkUrl, @ClassDir, @ParentDir, @SkinID, @ShowOnTop, @ShowOnIndex, @IsElite, @EnableAdd, @MaxPerPage, @ItemListOrderType, @ItemOpenType, @ItemCount, @CheckComment, @PresentExp, @ShopCount, @ClassSkinID, @TemplateID, @ProductTemplateID, @ProductSkinID,@HasParameter);\r\nSELECT ClassID, ChannelID, SpecialID, ClassName, ClassType, OpenType, ParentID, ParentPath, ParentDepth, Depth, RootID, Child, arrChildID, PrevID, NextID, OrderByID, Tips, ReadMe, LinkUrl, ClassDir, ParentDir, SkinID, ShowOnTop, ShowOnIndex, IsElite, EnableAdd, MaxPerPage, ItemListOrderType, ItemOpenType, ItemCount, CheckComment, PresentExp, ShopCount, ClassSkinID,HasParameter, TemplateID, ProductTemplateID, ProductSkinID FROM HLShop_Class WHERE (ClassID = SCOPE_IDENTITY()) ORDER BY RootID, OrderByID";
			this._adapter.InsertCommand.CommandType = CommandType.Text;
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ChannelID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ChannelID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@SpecialID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SpecialID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ClassName", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ClassName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ClassType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ClassType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@OpenType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OpenType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ParentID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ParentID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ParentPath", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ParentPath", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ParentDepth", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ParentDepth", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Depth", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Depth", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@RootID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "RootID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Child", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Child", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@arrChildID", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "arrChildID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PrevID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PrevID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@NextID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "NextID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@OrderByID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OrderByID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Tips", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Tips", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ReadMe", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "ReadMe", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "LinkUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ClassDir", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ClassDir", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ParentDir", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ParentDir", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@SkinID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SkinID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShowOnTop", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "ShowOnTop", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShowOnIndex", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "ShowOnIndex", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@IsElite", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "IsElite", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@EnableAdd", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "EnableAdd", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@MaxPerPage", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "MaxPerPage", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ItemListOrderType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ItemListOrderType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ItemOpenType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ItemOpenType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ItemCount", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ItemCount", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@CheckComment", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "CheckComment", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentExp", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentExp", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopCount", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopCount", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ClassSkinID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ClassSkinID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TemplateID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TemplateID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ProductTemplateID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ProductTemplateID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ProductSkinID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ProductSkinID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@HasParameter", SqlDbType.Bit, 0, ParameterDirection.Input, 1, 0, "HasParameter", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand = new SqlCommand();
			this._adapter.UpdateCommand.Connection = this.Connection;
			this._adapter.UpdateCommand.CommandText = "UPDATE [HLShop_Class] SET [ChannelID] = @ChannelID, [SpecialID] = @SpecialID, [ClassName] = @ClassName, [ClassType] = @ClassType, [OpenType] = @OpenType, [ParentID] = @ParentID, [ParentPath] = @ParentPath, [ParentDepth] = @ParentDepth, [Depth] = @Depth, [RootID] = @RootID, [Child] = @Child, [arrChildID] = @arrChildID, [PrevID] = @PrevID, [NextID] = @NextID, [OrderByID] = @OrderByID, [Tips] = @Tips, [ReadMe] = @ReadMe, [LinkUrl] = @LinkUrl, [ClassDir] = @ClassDir, [ParentDir] = @ParentDir, [SkinID] = @SkinID, [ShowOnTop] = @ShowOnTop, [ShowOnIndex] = @ShowOnIndex, [IsElite] = @IsElite, [EnableAdd] = @EnableAdd, [MaxPerPage] = @MaxPerPage, [ItemListOrderType] = @ItemListOrderType, [ItemOpenType] = @ItemOpenType, [ItemCount] = @ItemCount, [CheckComment] = @CheckComment, [PresentExp] = @PresentExp, [ShopCount] = @ShopCount, [ClassSkinID] = @ClassSkinID, [TemplateID] = @TemplateID, [ProductTemplateID] = @ProductTemplateID, [ProductSkinID] = @ProductSkinID, [HasParameter] = @HasParameter WHERE (([ClassID] = @Original_ClassID));\r\nSELECT ClassID, ChannelID, SpecialID, ClassName, ClassType, OpenType, ParentID, ParentPath, ParentDepth, Depth, RootID, Child, arrChildID, PrevID, NextID, OrderByID, Tips, ReadMe, LinkUrl, ClassDir, ParentDir, SkinID, ShowOnTop, ShowOnIndex, IsElite, EnableAdd, MaxPerPage, ItemListOrderType, ItemOpenType, ItemCount, CheckComment, PresentExp, ShopCount, ClassSkinID,HasParameter, TemplateID, ProductTemplateID, ProductSkinID FROM HLShop_Class WHERE (ClassID = @ClassID) ORDER BY RootID, OrderByID";
			this._adapter.UpdateCommand.CommandType = CommandType.Text;
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ChannelID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ChannelID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@SpecialID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SpecialID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ClassName", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ClassName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ClassType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ClassType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@OpenType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OpenType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ParentID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ParentID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ParentPath", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ParentPath", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ParentDepth", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ParentDepth", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Depth", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Depth", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@RootID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "RootID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Child", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Child", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@arrChildID", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "arrChildID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PrevID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PrevID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@NextID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "NextID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@OrderByID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OrderByID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Tips", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Tips", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ReadMe", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "ReadMe", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "LinkUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ClassDir", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ClassDir", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ParentDir", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ParentDir", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@SkinID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SkinID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShowOnTop", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "ShowOnTop", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShowOnIndex", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "ShowOnIndex", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@IsElite", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "IsElite", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@EnableAdd", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "EnableAdd", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@MaxPerPage", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "MaxPerPage", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ItemListOrderType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ItemListOrderType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ItemOpenType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ItemOpenType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ItemCount", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ItemCount", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@CheckComment", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "CheckComment", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentExp", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentExp", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopCount", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopCount", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ClassSkinID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ClassSkinID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TemplateID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TemplateID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ProductTemplateID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ProductTemplateID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ProductSkinID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ProductSkinID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@HasParameter", SqlDbType.Bit, 0, ParameterDirection.Input, 1, 0, "HasParameter", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Original_ClassID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ClassID", DataRowVersion.Original, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ClassID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ClassID", DataRowVersion.Current, false, null, "", "", ""));
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitConnection()
		{
			this._connection = new SqlConnection();
			this._connection.ConnectionString = Conn.CurrenConnectionStrings;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitCommandCollection()
		{
			this._commandCollection = new SqlCommand[18];
			this._commandCollection[0] = new SqlCommand();
			this._commandCollection[0].Connection = this.Connection;
			this._commandCollection[0].CommandText = "SELECT *\r\nFROM HLShop_Class\r\nORDER BY RootID, OrderByID,Depth asc";
			this._commandCollection[0].CommandType = CommandType.Text;
			this._commandCollection[1] = new SqlCommand();
			this._commandCollection[1].Connection = this.Connection;
			this._commandCollection[1].CommandText = "select ClassID from hlshop_Class where RootID=@RootID and Depth>0 order by OrderByID,Depth asc;";
			this._commandCollection[1].CommandType = CommandType.Text;
			this._commandCollection[1].Parameters.Add(new SqlParameter("@RootID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "RootID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2] = new SqlCommand();
			this._commandCollection[2].Connection = this.Connection;
			this._commandCollection[2].CommandText = "SELECT ChannelID, CheckComment, Child, ClassDir, ClassID, ClassName, ClassSkinID, ClassType, Depth, EnableAdd, IsElite, ItemCount, ItemListOrderType, ItemOpenType, LinkUrl, MaxPerPage, NextID, OpenType, OrderByID, ParentDepth, ParentDir, ParentID, ParentPath, PresentExp, PrevID, ProductSkinID, ProductTemplateID, ReadMe, RootID, ShopCount, ShowOnIndex, ShowOnTop, SkinID, SpecialID, TemplateID, Tips, arrChildID,HasParameter FROM HLShop_Class ORDER BY RootID, OrderByID";
			this._commandCollection[2].CommandType = CommandType.Text;
			this._commandCollection[3] = new SqlCommand();
			this._commandCollection[3].Connection = this.Connection;
			this._commandCollection[3].CommandText = "SELECT ChannelID, CheckComment, Child, ClassDir, ClassID, ClassName, ClassSkinID, ClassType, Depth, EnableAdd, IsElite, ItemCount, ItemListOrderType, ItemOpenType, LinkUrl, MaxPerPage, NextID, OpenType, OrderByID, ParentDepth, ParentDir, ParentID, ParentPath, PresentExp, PrevID, ProductSkinID, ProductTemplateID, ReadMe, RootID, ShopCount, ShowOnIndex, ShowOnTop, SkinID, SpecialID, TemplateID, Tips, arrChildID,HasParameter FROM HLShop_Class WHERE (ParentID = 0) ORDER BY RootID";
			this._commandCollection[3].CommandType = CommandType.Text;
			this._commandCollection[4] = new SqlCommand();
			this._commandCollection[4].Connection = this.Connection;
			this._commandCollection[4].CommandText = "SELECT ChannelID, CheckComment, Child, ClassDir, ClassID, ClassName, ClassSkinID, ClassType, Depth, EnableAdd, IsElite, ItemCount, ItemListOrderType, ItemOpenType, LinkUrl, MaxPerPage, NextID, OpenType, OrderByID, ParentDepth, ParentDir, ParentID, ParentPath, PresentExp, PrevID, ProductSkinID, ProductTemplateID, ReadMe, RootID, ShopCount, ShowOnIndex, ShowOnTop, SkinID, SpecialID, TemplateID, Tips, arrChildID,HasParameter FROM HLShop_Class WHERE (ParentID = @ClassID) ORDER BY RootID, OrderByID";
			this._commandCollection[4].CommandType = CommandType.Text;
			this._commandCollection[4].Parameters.Add(new SqlParameter("@ClassID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ParentID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[5] = new SqlCommand();
			this._commandCollection[5].Connection = this.Connection;
			this._commandCollection[5].CommandText = "SELECT * FROM HLShop_Class WHERE (ClassID = @ClassID)";
			this._commandCollection[5].CommandType = CommandType.Text;
			this._commandCollection[5].Parameters.Add(new SqlParameter("@ClassID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[6] = new SqlCommand();
			this._commandCollection[6].Connection = this.Connection;
			this._commandCollection[6].CommandText = "SELECT     ClassID, ChannelID, SpecialID, ClassName, ClassType, OpenType, ParentID, ParentPath, ParentDepth, Depth, RootID, Child, arrChildID, PrevID, \r\n                      NextID, OrderByID, Tips, ReadMe, LinkUrl, ClassDir, ParentDir, SkinID, ShowOnTop, ShowOnIndex, IsElite, EnableAdd, MaxPerPage, \r\n                      ItemListOrderType, ItemOpenType, ItemCount, CheckComment, PresentExp, ShopCount, ClassSkinID, TemplateID, ProductTemplateID, \r\n                      ProductSkinID,HasParameter\r\nFROM         HLShop_Class\r\nWHERE     (ClassName LIKE '%' + @classname + '%')";
			this._commandCollection[6].CommandType = CommandType.Text;
			this._commandCollection[6].Parameters.Add(new SqlParameter("@classname", SqlDbType.NVarChar, 50, ParameterDirection.Input, 0, 0, "ClassName", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[7] = new SqlCommand();
			this._commandCollection[7].Connection = this.Connection;
			this._commandCollection[7].CommandText = "SELECT ChannelID, CheckComment, Child, ClassDir, ClassID, ClassName, ClassSkinID, ClassType, Depth, EnableAdd, IsElite, ItemCount, ItemListOrderType, ItemOpenType, LinkUrl, MaxPerPage, NextID, OpenType, OrderByID, ParentDepth, ParentDir, ParentID, ParentPath, PresentExp, PrevID, ProductSkinID, ProductTemplateID, ReadMe, RootID, ShopCount, ShowOnIndex, ShowOnTop, SkinID, SpecialID, TemplateID, Tips, arrChildID,HasParameter FROM HLShop_Class WHERE (RootID = @RootID) ORDER BY ClassID";
			this._commandCollection[7].CommandType = CommandType.Text;
			this._commandCollection[7].Parameters.Add(new SqlParameter("@RootID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "RootID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8] = new SqlCommand();
			this._commandCollection[8].Connection = this.Connection;
			this._commandCollection[8].CommandText = "SELECT ChannelID, CheckComment, Child, ClassDir, ClassID, ClassName, ClassSkinID, ClassType, Depth, EnableAdd, IsElite, ItemCount, ItemListOrderType, ItemOpenType, LinkUrl, MaxPerPage, NextID, OpenType, OrderByID, ParentDepth, ParentDir, ParentID, ParentPath, PresentExp, PrevID, ProductSkinID, ProductTemplateID, ReadMe, RootID, ShopCount, ShowOnIndex, ShowOnTop, SkinID, SpecialID, TemplateID, Tips, arrChildID,HasParameter FROM HLShop_Class WHERE (SpecialID = @SpecialID) ORDER BY RootID, OrderByID";
			this._commandCollection[8].CommandType = CommandType.Text;
			this._commandCollection[8].Parameters.Add(new SqlParameter("@SpecialID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "SpecialID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9] = new SqlCommand();
			this._commandCollection[9].Connection = this.Connection;
			this._commandCollection[9].CommandText = "pr_SelectClassMapPath";
			this._commandCollection[9].CommandType = CommandType.StoredProcedure;
			this._commandCollection[9].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@ParentID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[10] = new SqlCommand();
			this._commandCollection[10].Connection = this.Connection;
			this._commandCollection[10].CommandText = "SELECT ClassID,ClassName\r\nFROM HLShop_Class\r\nWHERE ClassID=@ClassID";
			this._commandCollection[10].CommandType = CommandType.Text;
			this._commandCollection[10].Parameters.Add(new SqlParameter("@ClassID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[11] = new SqlCommand();
			this._commandCollection[11].Connection = this.Connection;
			this._commandCollection[11].CommandText = "SELECT ChannelID, CheckComment, Child, ClassDir, ClassID, ClassName, ClassSkinID, ClassType, Depth, EnableAdd, IsElite, ItemCount, ItemListOrderType, ItemOpenType, LinkUrl, MaxPerPage, NextID, OpenType, OrderByID, ParentDepth, ParentDir, ParentID, ParentPath, PresentExp, PrevID, ProductSkinID, ProductTemplateID, ReadMe, RootID, ShopCount, ShowOnIndex, ShowOnTop, SkinID, SpecialID, TemplateID, Tips, arrChildID,HasParameter FROM HLShop_Class WHERE (ParentID IN (SELECT ClassID FROM HLShop_Class AS HLShop_Class_1 WHERE (ParentID = 0))) ORDER BY RootID, OrderByID";
			this._commandCollection[11].CommandType = CommandType.Text;
			this._commandCollection[12] = new SqlCommand();
			this._commandCollection[12].Connection = this.Connection;
			this._commandCollection[12].CommandText = "pr_SelectClass";
			this._commandCollection[12].CommandType = CommandType.StoredProcedure;
			this._commandCollection[12].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[12].Parameters.Add(new SqlParameter("@ParentID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13] = new SqlCommand();
			this._commandCollection[13].Connection = this.Connection;
			this._commandCollection[13].CommandText = "pr_DeleteClass";
			this._commandCollection[13].CommandType = CommandType.StoredProcedure;
			this._commandCollection[13].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ClassID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14] = new SqlCommand();
			this._commandCollection[14].Connection = this.Connection;
			this._commandCollection[14].CommandText = "pr_InsertClass";
			this._commandCollection[14].CommandType = CommandType.StoredProcedure;
			this._commandCollection[14].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@ChannelID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@SpecialID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@ClassName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@ClassType", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@OpenType", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@ParentID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@Tips", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@ReadMe", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@ShowOnTop", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@ShowOnIndex", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@ItemListOrderType", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@IsElite", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@EnableAdd", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@MaxPerPage", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@ItemOpenType", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@ClassDir", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@TemplateID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@ClassSkinID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@ProductTemplateID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@ProductSkinID", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@Attributes_Type", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@HasParameter", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15] = new SqlCommand();
			this._commandCollection[15].Connection = this.Connection;
			this._commandCollection[15].CommandText = "pr_UpdateClass";
			this._commandCollection[15].CommandType = CommandType.StoredProcedure;
			this._commandCollection[15].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@ChannelID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@SpecialID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@ClassName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@Tips", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@ReadMe", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@ShowOnTop", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@ShowOnIndex", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@IsElite", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@EnableAdd", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@ItemListOrderType", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@MaxPerPage", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@ItemOpenType", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@ClassDir", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@TemplateID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@ClassSkinID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@ProductTemplateID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@ProductSkinID", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@ClassID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@ChildClassUseSkin", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@Attributes_Type", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@HasParameter", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16] = new SqlCommand();
			this._commandCollection[16].Connection = this.Connection;
			this._commandCollection[16].CommandText = "Pr_UpdateItemCountByProductClassID";
			this._commandCollection[16].CommandType = CommandType.StoredProcedure;
			this._commandCollection[16].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@ClassID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17] = new SqlCommand();
			this._commandCollection[17].Connection = this.Connection;
			this._commandCollection[17].CommandText = "UPDATE [HLShop_Class] SET   [SpecialID] = @FromSpecialID  WHERE  [SpecialID] =@ToSpecialID ";
			this._commandCollection[17].CommandType = CommandType.Text;
			this._commandCollection[17].Parameters.Add(new SqlParameter("@FromSpecialID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "SpecialID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17].Parameters.Add(new SqlParameter("@ToSpecialID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "SpecialID", DataRowVersion.Original, false, null, "", "", ""));
		}
		[DataObjectMethod(DataObjectMethodType.Select, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Class.HLShop_ClassDataTable GetAllClass()
		{
			this.Adapter.SelectCommand = this.CommandCollection[0];
			S_Class.HLShop_ClassDataTable hLShop_ClassDataTable = new S_Class.HLShop_ClassDataTable();
			this.Adapter.Fill(hLShop_ClassDataTable);
			return hLShop_ClassDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Class.HLShop_ClassDataTable GetRootChildClassIDByRootID(int? RootID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[1];
			if (RootID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = RootID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_Class.HLShop_ClassDataTable hLShop_ClassDataTable = new S_Class.HLShop_ClassDataTable();
			this.Adapter.Fill(hLShop_ClassDataTable);
			return hLShop_ClassDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Class.HLShop_ClassDataTable GetAllClassNameFillDropDown()
		{
			this.Adapter.SelectCommand = this.CommandCollection[2];
			S_Class.HLShop_ClassDataTable hLShop_ClassDataTable = new S_Class.HLShop_ClassDataTable();
			this.Adapter.Fill(hLShop_ClassDataTable);
			return hLShop_ClassDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Class.HLShop_ClassDataTable GetAllFirstClass()
		{
			this.Adapter.SelectCommand = this.CommandCollection[3];
			S_Class.HLShop_ClassDataTable hLShop_ClassDataTable = new S_Class.HLShop_ClassDataTable();
			this.Adapter.Fill(hLShop_ClassDataTable);
			return hLShop_ClassDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Class.HLShop_ClassDataTable GetChildClassByParentID(int? ClassID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[4];
			if (ClassID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ClassID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_Class.HLShop_ClassDataTable hLShop_ClassDataTable = new S_Class.HLShop_ClassDataTable();
			this.Adapter.Fill(hLShop_ClassDataTable);
			return hLShop_ClassDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Class.HLShop_ClassDataTable GetClassByClassID(int ClassID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[5];
			this.Adapter.SelectCommand.Parameters[0].Value = ClassID;
			S_Class.HLShop_ClassDataTable hLShop_ClassDataTable = new S_Class.HLShop_ClassDataTable();
			this.Adapter.Fill(hLShop_ClassDataTable);
			return hLShop_ClassDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Class.HLShop_ClassDataTable GetClassByClassName(string classname)
		{
			this.Adapter.SelectCommand = this.CommandCollection[6];
			if (classname == null)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = classname;
			}
			S_Class.HLShop_ClassDataTable hLShop_ClassDataTable = new S_Class.HLShop_ClassDataTable();
			this.Adapter.Fill(hLShop_ClassDataTable);
			return hLShop_ClassDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Class.HLShop_ClassDataTable GetClassByRootID(int? RootID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[7];
			if (RootID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = RootID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_Class.HLShop_ClassDataTable hLShop_ClassDataTable = new S_Class.HLShop_ClassDataTable();
			this.Adapter.Fill(hLShop_ClassDataTable);
			return hLShop_ClassDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Class.HLShop_ClassDataTable GetClassBySpecialID(int? SpecialID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[8];
			if (SpecialID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = SpecialID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_Class.HLShop_ClassDataTable hLShop_ClassDataTable = new S_Class.HLShop_ClassDataTable();
			this.Adapter.Fill(hLShop_ClassDataTable);
			return hLShop_ClassDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Class.HLShop_ClassDataTable GetClassMapPathByParentID(int? ParentID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[9];
			if (ParentID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ParentID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			S_Class.HLShop_ClassDataTable hLShop_ClassDataTable = new S_Class.HLShop_ClassDataTable();
			this.Adapter.Fill(hLShop_ClassDataTable);
			return hLShop_ClassDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Class.HLShop_ClassDataTable GetClassNameByClassID(int ClassID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[10];
			this.Adapter.SelectCommand.Parameters[0].Value = ClassID;
			S_Class.HLShop_ClassDataTable hLShop_ClassDataTable = new S_Class.HLShop_ClassDataTable();
			this.Adapter.Fill(hLShop_ClassDataTable);
			return hLShop_ClassDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Class.HLShop_ClassDataTable GetSecondClass()
		{
			this.Adapter.SelectCommand = this.CommandCollection[11];
			S_Class.HLShop_ClassDataTable hLShop_ClassDataTable = new S_Class.HLShop_ClassDataTable();
			this.Adapter.Fill(hLShop_ClassDataTable);
			return hLShop_ClassDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Fill, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int GetSelectClassByParentID1(S_Class.HLShop_ClassDataTable dataTable, int? ParentID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[12];
			if (ParentID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ParentID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (this.ClearBeforeFill)
			{
				dataTable.Clear();
			}
			return this.Adapter.Fill(dataTable);
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Class.HLShop_ClassDataTable GetSelectClassByParentID(int? ParentID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[12];
			if (ParentID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ParentID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			S_Class.HLShop_ClassDataTable hLShop_ClassDataTable = new S_Class.HLShop_ClassDataTable();
			this.Adapter.Fill(hLShop_ClassDataTable);
			return hLShop_ClassDataTable;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(S_Class.HLShop_ClassDataTable dataTable)
		{
			return this.Adapter.Update(dataTable);
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(S_Class dataSet)
		{
			return this.Adapter.Update(dataSet, "HLShop_Class");
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow dataRow)
		{
			return this.Adapter.Update(new DataRow[]
			{
				dataRow
			});
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow[] dataRows)
		{
			return this.Adapter.Update(dataRows);
		}
		[DataObjectMethod(DataObjectMethodType.Delete, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Delete(int Original_ClassID)
		{
			this.Adapter.DeleteCommand.Parameters[0].Value = Original_ClassID;
			ConnectionState state = this.Adapter.DeleteCommand.Connection.State;
			if ((this.Adapter.DeleteCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				this.Adapter.DeleteCommand.Connection.Open();
			}
			int result;
			try
			{
				int num = this.Adapter.DeleteCommand.ExecuteNonQuery();
				result = num;
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					this.Adapter.DeleteCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Insert, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Insert(int? ChannelID, int? SpecialID, string ClassName, int? ClassType, int? OpenType, int? ParentID, string ParentPath, int? ParentDepth, int? Depth, int? RootID, int? Child, string arrChildID, int? PrevID, int? NextID, int? OrderByID, string Tips, string ReadMe, string LinkUrl, string ClassDir, string ParentDir, int? SkinID, bool? ShowOnTop, bool? ShowOnIndex, bool? IsElite, bool? EnableAdd, int? MaxPerPage, int? ItemListOrderType, int? ItemOpenType, int? ItemCount, bool? CheckComment, int? PresentExp, int? ShopCount, int ClassSkinID, int? TemplateID, int? ProductTemplateID, int? ProductSkinID, bool? HasParameter)
		{
			if (ChannelID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[0].Value = ChannelID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (SpecialID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[1].Value = SpecialID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (ClassName == null)
			{
				this.Adapter.InsertCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[2].Value = ClassName;
			}
			if (ClassType.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[3].Value = ClassType.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[3].Value = System.DBNull.Value;
			}
			if (OpenType.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[4].Value = OpenType.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (ParentID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[5].Value = ParentID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[5].Value = System.DBNull.Value;
			}
			if (ParentPath == null)
			{
				this.Adapter.InsertCommand.Parameters[6].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[6].Value = ParentPath;
			}
			if (ParentDepth.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[7].Value = ParentDepth.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[7].Value = System.DBNull.Value;
			}
			if (Depth.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[8].Value = Depth.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[8].Value = System.DBNull.Value;
			}
			if (RootID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[9].Value = RootID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[9].Value = System.DBNull.Value;
			}
			if (Child.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[10].Value = Child.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[10].Value = System.DBNull.Value;
			}
			if (arrChildID == null)
			{
				this.Adapter.InsertCommand.Parameters[11].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[11].Value = arrChildID;
			}
			if (PrevID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[12].Value = PrevID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[12].Value = System.DBNull.Value;
			}
			if (NextID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[13].Value = NextID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[13].Value = System.DBNull.Value;
			}
			if (OrderByID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[14].Value = OrderByID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[14].Value = System.DBNull.Value;
			}
			if (Tips == null)
			{
				this.Adapter.InsertCommand.Parameters[15].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[15].Value = Tips;
			}
			if (ReadMe == null)
			{
				this.Adapter.InsertCommand.Parameters[16].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[16].Value = ReadMe;
			}
			if (LinkUrl == null)
			{
				this.Adapter.InsertCommand.Parameters[17].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[17].Value = LinkUrl;
			}
			if (ClassDir == null)
			{
				this.Adapter.InsertCommand.Parameters[18].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[18].Value = ClassDir;
			}
			if (ParentDir == null)
			{
				this.Adapter.InsertCommand.Parameters[19].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[19].Value = ParentDir;
			}
			if (SkinID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[20].Value = SkinID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[20].Value = System.DBNull.Value;
			}
			if (ShowOnTop.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[21].Value = ShowOnTop.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[21].Value = System.DBNull.Value;
			}
			if (ShowOnIndex.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[22].Value = ShowOnIndex.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[22].Value = System.DBNull.Value;
			}
			if (IsElite.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[23].Value = IsElite.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[23].Value = System.DBNull.Value;
			}
			if (EnableAdd.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[24].Value = EnableAdd.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[24].Value = System.DBNull.Value;
			}
			if (MaxPerPage.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[25].Value = MaxPerPage.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[25].Value = System.DBNull.Value;
			}
			if (ItemListOrderType.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[26].Value = ItemListOrderType.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[26].Value = System.DBNull.Value;
			}
			if (ItemOpenType.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[27].Value = ItemOpenType.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[27].Value = System.DBNull.Value;
			}
			if (ItemCount.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[28].Value = ItemCount.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[28].Value = System.DBNull.Value;
			}
			if (CheckComment.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[29].Value = CheckComment.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[29].Value = System.DBNull.Value;
			}
			if (PresentExp.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[30].Value = PresentExp.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[30].Value = System.DBNull.Value;
			}
			if (ShopCount.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[31].Value = ShopCount.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[31].Value = System.DBNull.Value;
			}
			this.Adapter.InsertCommand.Parameters[32].Value = ClassSkinID;
			if (TemplateID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[33].Value = TemplateID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[33].Value = System.DBNull.Value;
			}
			if (ProductTemplateID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[34].Value = ProductTemplateID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[34].Value = System.DBNull.Value;
			}
			if (ProductSkinID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[35].Value = ProductSkinID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[35].Value = System.DBNull.Value;
			}
			if (HasParameter.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[36].Value = HasParameter.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[36].Value = System.DBNull.Value;
			}
			ConnectionState state = this.Adapter.InsertCommand.Connection.State;
			if ((this.Adapter.InsertCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				this.Adapter.InsertCommand.Connection.Open();
			}
			int result;
			try
			{
				int num = this.Adapter.InsertCommand.ExecuteNonQuery();
				result = num;
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					this.Adapter.InsertCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(int? ChannelID, int? SpecialID, string ClassName, int? ClassType, int? OpenType, int? ParentID, string ParentPath, int? ParentDepth, int? Depth, int? RootID, int? Child, string arrChildID, int? PrevID, int? NextID, int? OrderByID, string Tips, string ReadMe, string LinkUrl, string ClassDir, string ParentDir, int? SkinID, bool? ShowOnTop, bool? ShowOnIndex, bool? IsElite, bool? EnableAdd, int? MaxPerPage, int? ItemListOrderType, int? ItemOpenType, int? ItemCount, bool? CheckComment, int? PresentExp, int? ShopCount, int ClassSkinID, int? TemplateID, int? ProductTemplateID, int? ProductSkinID, int Original_ClassID, int ClassID, bool? HasParameter)
		{
			if (ChannelID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[0].Value = ChannelID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (SpecialID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[1].Value = SpecialID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (ClassName == null)
			{
				this.Adapter.UpdateCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[2].Value = ClassName;
			}
			if (ClassType.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[3].Value = ClassType.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[3].Value = System.DBNull.Value;
			}
			if (OpenType.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[4].Value = OpenType.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (ParentID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[5].Value = ParentID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[5].Value = System.DBNull.Value;
			}
			if (ParentPath == null)
			{
				this.Adapter.UpdateCommand.Parameters[6].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[6].Value = ParentPath;
			}
			if (ParentDepth.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[7].Value = ParentDepth.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[7].Value = System.DBNull.Value;
			}
			if (Depth.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[8].Value = Depth.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[8].Value = System.DBNull.Value;
			}
			if (RootID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[9].Value = RootID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[9].Value = System.DBNull.Value;
			}
			if (Child.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[10].Value = Child.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[10].Value = System.DBNull.Value;
			}
			if (arrChildID == null)
			{
				this.Adapter.UpdateCommand.Parameters[11].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[11].Value = arrChildID;
			}
			if (PrevID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[12].Value = PrevID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[12].Value = System.DBNull.Value;
			}
			if (NextID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[13].Value = NextID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[13].Value = System.DBNull.Value;
			}
			if (OrderByID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[14].Value = OrderByID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[14].Value = System.DBNull.Value;
			}
			if (Tips == null)
			{
				this.Adapter.UpdateCommand.Parameters[15].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[15].Value = Tips;
			}
			if (ReadMe == null)
			{
				this.Adapter.UpdateCommand.Parameters[16].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[16].Value = ReadMe;
			}
			if (LinkUrl == null)
			{
				this.Adapter.UpdateCommand.Parameters[17].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[17].Value = LinkUrl;
			}
			if (ClassDir == null)
			{
				this.Adapter.UpdateCommand.Parameters[18].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[18].Value = ClassDir;
			}
			if (ParentDir == null)
			{
				this.Adapter.UpdateCommand.Parameters[19].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[19].Value = ParentDir;
			}
			if (SkinID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[20].Value = SkinID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[20].Value = System.DBNull.Value;
			}
			if (ShowOnTop.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[21].Value = ShowOnTop.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[21].Value = System.DBNull.Value;
			}
			if (ShowOnIndex.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[22].Value = ShowOnIndex.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[22].Value = System.DBNull.Value;
			}
			if (IsElite.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[23].Value = IsElite.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[23].Value = System.DBNull.Value;
			}
			if (EnableAdd.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[24].Value = EnableAdd.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[24].Value = System.DBNull.Value;
			}
			if (MaxPerPage.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[25].Value = MaxPerPage.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[25].Value = System.DBNull.Value;
			}
			if (ItemListOrderType.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[26].Value = ItemListOrderType.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[26].Value = System.DBNull.Value;
			}
			if (ItemOpenType.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[27].Value = ItemOpenType.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[27].Value = System.DBNull.Value;
			}
			if (ItemCount.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[28].Value = ItemCount.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[28].Value = System.DBNull.Value;
			}
			if (CheckComment.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[29].Value = CheckComment.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[29].Value = System.DBNull.Value;
			}
			if (PresentExp.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[30].Value = PresentExp.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[30].Value = System.DBNull.Value;
			}
			if (ShopCount.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[31].Value = ShopCount.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[31].Value = System.DBNull.Value;
			}
			this.Adapter.UpdateCommand.Parameters[32].Value = ClassSkinID;
			if (TemplateID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[33].Value = TemplateID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[33].Value = System.DBNull.Value;
			}
			if (ProductTemplateID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[34].Value = ProductTemplateID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[34].Value = System.DBNull.Value;
			}
			if (ProductSkinID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[35].Value = ProductSkinID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[35].Value = System.DBNull.Value;
			}
			if (HasParameter.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[36].Value = HasParameter.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[36].Value = System.DBNull.Value;
			}
			this.Adapter.UpdateCommand.Parameters[36].Value = Original_ClassID;
			this.Adapter.UpdateCommand.Parameters[37].Value = ClassID;
			ConnectionState state = this.Adapter.UpdateCommand.Connection.State;
			if ((this.Adapter.UpdateCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				this.Adapter.UpdateCommand.Connection.Open();
			}
			int result;
			try
			{
				int num = this.Adapter.UpdateCommand.ExecuteNonQuery();
				result = num;
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					this.Adapter.UpdateCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Delete, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int HLShop_DeleteClass(int? ClassID)
		{
			SqlCommand sqlCommand = this.CommandCollection[13];
			if (ClassID.HasValue)
			{
				sqlCommand.Parameters[1].Value = ClassID.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int HLShop_InsertClass(int? ChannelID, int? SpecialID, string ClassName, int? ClassType, int? OpenType, int? ParentID, string Tips, string ReadMe, bool? ShowOnTop, bool? ShowOnIndex, int? ItemListOrderType, bool? IsElite, bool? EnableAdd, int? MaxPerPage, int? ItemOpenType, string ClassDir, int? TemplateID, int? ClassSkinID, int? ProductTemplateID, string ProductSkinID, string Attributes_Type, bool? HasParameter)
		{
			SqlCommand sqlCommand = this.CommandCollection[14];
			if (ChannelID.HasValue)
			{
				sqlCommand.Parameters[1].Value = ChannelID.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (SpecialID.HasValue)
			{
				sqlCommand.Parameters[2].Value = SpecialID.Value;
			}
			else
			{
				sqlCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (ClassName == null)
			{
				sqlCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[3].Value = ClassName;
			}
			if (ClassType.HasValue)
			{
				sqlCommand.Parameters[4].Value = ClassType.Value;
			}
			else
			{
				sqlCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (OpenType.HasValue)
			{
				sqlCommand.Parameters[5].Value = OpenType.Value;
			}
			else
			{
				sqlCommand.Parameters[5].Value = System.DBNull.Value;
			}
			if (ParentID.HasValue)
			{
				sqlCommand.Parameters[6].Value = ParentID.Value;
			}
			else
			{
				sqlCommand.Parameters[6].Value = System.DBNull.Value;
			}
			if (Tips == null)
			{
				sqlCommand.Parameters[7].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[7].Value = Tips;
			}
			if (ReadMe == null)
			{
				sqlCommand.Parameters[8].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[8].Value = ReadMe;
			}
			if (ShowOnTop.HasValue)
			{
				sqlCommand.Parameters[9].Value = ShowOnTop.Value;
			}
			else
			{
				sqlCommand.Parameters[9].Value = System.DBNull.Value;
			}
			if (ShowOnIndex.HasValue)
			{
				sqlCommand.Parameters[10].Value = ShowOnIndex.Value;
			}
			else
			{
				sqlCommand.Parameters[10].Value = System.DBNull.Value;
			}
			if (ItemListOrderType.HasValue)
			{
				sqlCommand.Parameters[11].Value = ItemListOrderType.Value;
			}
			else
			{
				sqlCommand.Parameters[11].Value = System.DBNull.Value;
			}
			if (IsElite.HasValue)
			{
				sqlCommand.Parameters[12].Value = IsElite.Value;
			}
			else
			{
				sqlCommand.Parameters[12].Value = System.DBNull.Value;
			}
			if (EnableAdd.HasValue)
			{
				sqlCommand.Parameters[13].Value = EnableAdd.Value;
			}
			else
			{
				sqlCommand.Parameters[13].Value = System.DBNull.Value;
			}
			if (MaxPerPage.HasValue)
			{
				sqlCommand.Parameters[14].Value = MaxPerPage.Value;
			}
			else
			{
				sqlCommand.Parameters[14].Value = System.DBNull.Value;
			}
			if (ItemOpenType.HasValue)
			{
				sqlCommand.Parameters[15].Value = ItemOpenType.Value;
			}
			else
			{
				sqlCommand.Parameters[15].Value = System.DBNull.Value;
			}
			if (ClassDir == null)
			{
				sqlCommand.Parameters[16].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[16].Value = ClassDir;
			}
			if (TemplateID.HasValue)
			{
				sqlCommand.Parameters[17].Value = TemplateID.Value;
			}
			else
			{
				sqlCommand.Parameters[17].Value = System.DBNull.Value;
			}
			if (ClassSkinID.HasValue)
			{
				sqlCommand.Parameters[18].Value = ClassSkinID.Value;
			}
			else
			{
				sqlCommand.Parameters[18].Value = System.DBNull.Value;
			}
			if (ProductTemplateID.HasValue)
			{
				sqlCommand.Parameters[19].Value = ProductTemplateID.Value;
			}
			else
			{
				sqlCommand.Parameters[19].Value = System.DBNull.Value;
			}
			if (ProductSkinID == null)
			{
				sqlCommand.Parameters[20].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[20].Value = ProductSkinID;
			}
			if (Attributes_Type == null)
			{
				sqlCommand.Parameters[21].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[21].Value = Attributes_Type;
			}
			if (HasParameter.HasValue)
			{
				sqlCommand.Parameters[22].Value = HasParameter.Value;
			}
			else
			{
				sqlCommand.Parameters[22].Value = System.DBNull.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateClass(int? ChannelID, int? SpecialID, string ClassName, string Tips, string ReadMe, bool? ShowOnTop, bool? ShowOnIndex, bool? IsElite, bool? EnableAdd, int? ItemListOrderType, int? MaxPerPage, int? ItemOpenType, string ClassDir, int? TemplateID, int? ClassSkinID, int? ProductTemplateID, string ProductSkinID, int? ClassID, bool? ChildClassUseSkin, string Attributes_Type, bool? HasParameter)
		{
			SqlCommand sqlCommand = this.CommandCollection[15];
			if (ChannelID.HasValue)
			{
				sqlCommand.Parameters[1].Value = ChannelID.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (SpecialID.HasValue)
			{
				sqlCommand.Parameters[2].Value = SpecialID.Value;
			}
			else
			{
				sqlCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (ClassName == null)
			{
				sqlCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[3].Value = ClassName;
			}
			if (Tips == null)
			{
				sqlCommand.Parameters[4].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[4].Value = Tips;
			}
			if (ReadMe == null)
			{
				sqlCommand.Parameters[5].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[5].Value = ReadMe;
			}
			if (ShowOnTop.HasValue)
			{
				sqlCommand.Parameters[6].Value = ShowOnTop.Value;
			}
			else
			{
				sqlCommand.Parameters[6].Value = System.DBNull.Value;
			}
			if (ShowOnIndex.HasValue)
			{
				sqlCommand.Parameters[7].Value = ShowOnIndex.Value;
			}
			else
			{
				sqlCommand.Parameters[7].Value = System.DBNull.Value;
			}
			if (IsElite.HasValue)
			{
				sqlCommand.Parameters[8].Value = IsElite.Value;
			}
			else
			{
				sqlCommand.Parameters[8].Value = System.DBNull.Value;
			}
			if (EnableAdd.HasValue)
			{
				sqlCommand.Parameters[9].Value = EnableAdd.Value;
			}
			else
			{
				sqlCommand.Parameters[9].Value = System.DBNull.Value;
			}
			if (ItemListOrderType.HasValue)
			{
				sqlCommand.Parameters[10].Value = ItemListOrderType.Value;
			}
			else
			{
				sqlCommand.Parameters[10].Value = System.DBNull.Value;
			}
			if (MaxPerPage.HasValue)
			{
				sqlCommand.Parameters[11].Value = MaxPerPage.Value;
			}
			else
			{
				sqlCommand.Parameters[11].Value = System.DBNull.Value;
			}
			if (ItemOpenType.HasValue)
			{
				sqlCommand.Parameters[12].Value = ItemOpenType.Value;
			}
			else
			{
				sqlCommand.Parameters[12].Value = System.DBNull.Value;
			}
			if (ClassDir == null)
			{
				sqlCommand.Parameters[13].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[13].Value = ClassDir;
			}
			if (TemplateID.HasValue)
			{
				sqlCommand.Parameters[14].Value = TemplateID.Value;
			}
			else
			{
				sqlCommand.Parameters[14].Value = System.DBNull.Value;
			}
			if (ClassSkinID.HasValue)
			{
				sqlCommand.Parameters[15].Value = ClassSkinID.Value;
			}
			else
			{
				sqlCommand.Parameters[15].Value = System.DBNull.Value;
			}
			if (ProductTemplateID.HasValue)
			{
				sqlCommand.Parameters[16].Value = ProductTemplateID.Value;
			}
			else
			{
				sqlCommand.Parameters[16].Value = System.DBNull.Value;
			}
			if (ProductSkinID == null)
			{
				sqlCommand.Parameters[17].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[17].Value = ProductSkinID;
			}
			if (ClassID.HasValue)
			{
				sqlCommand.Parameters[18].Value = ClassID.Value;
			}
			else
			{
				sqlCommand.Parameters[18].Value = System.DBNull.Value;
			}
			if (ChildClassUseSkin.HasValue)
			{
				sqlCommand.Parameters[19].Value = ChildClassUseSkin.Value;
			}
			else
			{
				sqlCommand.Parameters[19].Value = System.DBNull.Value;
			}
			if (Attributes_Type == null)
			{
				sqlCommand.Parameters[20].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[20].Value = Attributes_Type;
			}
			if (!HasParameter.HasValue)
			{
				sqlCommand.Parameters[21].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[21].Value = HasParameter.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateItemCountByProductClassID(int? ClassID, string Type)
		{
			SqlCommand sqlCommand = this.CommandCollection[16];
			if (ClassID.HasValue)
			{
				sqlCommand.Parameters[1].Value = ClassID.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (Type == null)
			{
				sqlCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[2].Value = Type;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateSpecial(int? FromSpecialID, int? ToSpecialID)
		{
			SqlCommand sqlCommand = this.CommandCollection[17];
			if (FromSpecialID.HasValue)
			{
				sqlCommand.Parameters[0].Value = FromSpecialID.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (ToSpecialID.HasValue)
			{
				sqlCommand.Parameters[1].Value = ToSpecialID.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
	}
}
